Overview
Brought to you by YData
Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 3434 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 456.1 KiB |
| Average record size in memory | 136.0 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 4 |
| DateTime | 2 |
| Text | 2 |
Dropoff ID is highly overall correlated with Dropoff Longitude and 1 other fields | High correlation |
Dropoff Latitude is highly overall correlated with district_dropoff | High correlation |
Dropoff Longitude is highly overall correlated with Dropoff ID and 1 other fields | High correlation |
Passenger status is highly overall correlated with Status | High correlation |
Pickup ID is highly overall correlated with Pickup Longitude and 1 other fields | High correlation |
Pickup Latitude is highly overall correlated with district_pickup | High correlation |
Pickup Longitude is highly overall correlated with Pickup ID and 1 other fields | High correlation |
Status is highly overall correlated with Passenger status | High correlation |
district_dropoff is highly overall correlated with Dropoff ID and 2 other fields | High correlation |
district_pickup is highly overall correlated with Pickup ID and 2 other fields | High correlation |
Booking ID has unique values | Unique |
Pickup ID has 680 (19.8%) zeros | Zeros |
Dropoff ID has 616 (17.9%) zeros | Zeros |
Reproduction
| Analysis started | 2024-11-13 20:36:07.506026 |
|---|---|
| Analysis finished | 2024-11-13 20:36:17.172214 |
| Duration | 9.67 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
Booking ID
Real number (ℝ)
Unique
| Distinct | 3434 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 260478.42 |
| Minimum | 241740 |
|---|---|
| Maximum | 270349 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 53.7 KiB |
Quantile statistics
| Minimum | 241740 |
|---|---|
| 5-th percentile | 249425.65 |
| Q1 | 256348.25 |
| median | 260749 |
| Q3 | 265275.25 |
| 95-th percentile | 269100.8 |
| Maximum | 270349 |
| Range | 28609 |
| Interquartile range (IQR) | 8927 |
Descriptive statistics
| Standard deviation | 5936.3035 |
|---|---|
| Coefficient of variation (CV) | 0.022790001 |
| Kurtosis | -0.14757498 |
| Mean | 260478.42 |
| Median Absolute Deviation (MAD) | 4471 |
| Skewness | -0.48370519 |
| Sum | 8.9448289 × 108 |
| Variance | 35239699 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 253212 | 1 | < 0.1% |
| 265273 | 1 | < 0.1% |
| 260719 | 1 | < 0.1% |
| 264040 | 1 | < 0.1% |
| 265006 | 1 | < 0.1% |
| 264352 | 1 | < 0.1% |
| 265196 | 1 | < 0.1% |
| 251907 | 1 | < 0.1% |
| 265201 | 1 | < 0.1% |
| 265445 | 1 | < 0.1% |
| Other values (3424) | 3424 |
| Value | Count | Frequency (%) |
| 241740 | 1 | |
| 241741 | 1 | |
| 241742 | 1 | |
| 242097 | 1 | |
| 242098 | 1 | |
| 242540 | 1 | |
| 242944 | 1 | |
| 242945 | 1 | |
| 242994 | 1 | |
| 242996 | 1 |
| Value | Count | Frequency (%) |
| 270349 | 1 | |
| 270342 | 1 | |
| 270338 | 1 | |
| 270330 | 1 | |
| 270328 | 1 | |
| 270327 | 1 | |
| 270320 | 1 | |
| 270319 | 1 | |
| 270318 | 1 | |
| 270317 | 1 |
Status
Categorical
High correlation
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.7 KiB |
| Validated | |
|---|---|
| Cancelled by client | |
| Cancelled by driver | |
| Changed by admin | 6 |
| Changed by client | 4 |
Length
| Max length | 24 |
|---|---|
| Median length | 9 |
| Mean length | 13.174141 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cancelled by client |
|---|---|
| 2nd row | Cancelled by client |
| 3rd row | Cancelled by driver |
| 4th row | Validated |
| 5th row | Cancelled by driver |
Common Values
| Value | Count | Frequency (%) |
| Validated | 1999 | |
| Cancelled by client | 1024 | |
| Cancelled by driver | 399 | 11.6% |
| Changed by admin | 6 | 0.2% |
| Changed by client | 4 | 0.1% |
| Cancelled by call center | 2 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| validated | 1999 | |
| by | 1435 | |
| cancelled | 1425 | |
| client | 1028 | |
| driver | 399 | 6.3% |
| changed | 10 | 0.2% |
| admin | 6 | 0.1% |
| call | 2 | < 0.1% |
| center | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 6290 | |
| l | 5881 | |
| d | 5838 | |
| a | 5441 | |
| i | 3432 | |
| t | 3029 | |
| 2872 | ||
| n | 2471 | 5.5% |
| c | 2457 | 5.4% |
| V | 1999 | 4.4% |
| Other values (8) | 5530 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 45240 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 6290 | |
| l | 5881 | |
| d | 5838 | |
| a | 5441 | |
| i | 3432 | |
| t | 3029 | |
| 2872 | ||
| n | 2471 | 5.5% |
| c | 2457 | 5.4% |
| V | 1999 | 4.4% |
| Other values (8) | 5530 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 45240 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 6290 | |
| l | 5881 | |
| d | 5838 | |
| a | 5441 | |
| i | 3432 | |
| t | 3029 | |
| 2872 | ||
| n | 2471 | 5.5% |
| c | 2457 | 5.4% |
| V | 1999 | 4.4% |
| Other values (8) | 5530 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 45240 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 6290 | |
| l | 5881 | |
| d | 5838 | |
| a | 5441 | |
| i | 3432 | |
| t | 3029 | |
| 2872 | ||
| n | 2471 | 5.5% |
| c | 2457 | 5.4% |
| V | 1999 | 4.4% |
| Other values (8) | 5530 |
Passenger status
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.7 KiB |
| Trip completed | |
|---|---|
| Cancelled |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 11.9106 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cancelled |
|---|---|
| 2nd row | Cancelled |
| 3rd row | Cancelled |
| 4th row | Trip completed |
| 5th row | Cancelled |
Common Values
| Value | Count | Frequency (%) |
| Trip completed | 1999 | |
| Cancelled | 1435 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| trip | 1999 | |
| completed | 1999 | |
| cancelled | 1435 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 6868 | |
| l | 4869 | |
| p | 3998 | |
| c | 3434 | |
| d | 3434 | |
| T | 1999 | 4.9% |
| r | 1999 | 4.9% |
| i | 1999 | 4.9% |
| 1999 | 4.9% | |
| o | 1999 | 4.9% |
| Other values (5) | 8303 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 40901 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 6868 | |
| l | 4869 | |
| p | 3998 | |
| c | 3434 | |
| d | 3434 | |
| T | 1999 | 4.9% |
| r | 1999 | 4.9% |
| i | 1999 | 4.9% |
| 1999 | 4.9% | |
| o | 1999 | 4.9% |
| Other values (5) | 8303 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 40901 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 6868 | |
| l | 4869 | |
| p | 3998 | |
| c | 3434 | |
| d | 3434 | |
| T | 1999 | 4.9% |
| r | 1999 | 4.9% |
| i | 1999 | 4.9% |
| 1999 | 4.9% | |
| o | 1999 | 4.9% |
| Other values (5) | 8303 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 40901 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 6868 | |
| l | 4869 | |
| p | 3998 | |
| c | 3434 | |
| d | 3434 | |
| T | 1999 | 4.9% |
| r | 1999 | 4.9% |
| i | 1999 | 4.9% |
| 1999 | 4.9% | |
| o | 1999 | 4.9% |
| Other values (5) | 8303 |
Passengers
Real number (ℝ)
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2673267 |
| Minimum | 1 |
|---|---|
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 53.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.76376466 |
|---|---|
| Coefficient of variation (CV) | 0.60265805 |
| Kurtosis | 24.258398 |
| Mean | 1.2673267 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.2956108 |
| Sum | 4352 |
| Variance | 0.58333646 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 1 | 2872 | |
| 2 | 373 | 10.9% |
| 3 | 97 | 2.8% |
| 4 | 55 | 1.6% |
| 5 | 20 | 0.6% |
| 8 | 8 | 0.2% |
| 7 | 5 | 0.1% |
| 6 | 4 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 2872 | |
| 2 | 373 | 10.9% |
| 3 | 97 | 2.8% |
| 4 | 55 | 1.6% |
| 5 | 20 | 0.6% |
| 6 | 4 | 0.1% |
| 7 | 5 | 0.1% |
| 8 | 8 | 0.2% |
| Value | Count | Frequency (%) |
| 8 | 8 | 0.2% |
| 7 | 5 | 0.1% |
| 6 | 4 | 0.1% |
| 5 | 20 | 0.6% |
| 4 | 55 | 1.6% |
| 3 | 97 | 2.8% |
| 2 | 373 | 10.9% |
| 1 | 2872 |
Pickup ID
Real number (ℝ)
High correlation Zeros
| Distinct | 64 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.654339 |
| Minimum | 0 |
|---|---|
| Maximum | 68 |
| Zeros | 680 |
| Zeros (%) | 19.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 53.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 4 |
| median | 21 |
| Q3 | 31 |
| 95-th percentile | 55.7 |
| Maximum | 68 |
| Range | 68 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 18.206847 |
|---|---|
| Coefficient of variation (CV) | 0.80368035 |
| Kurtosis | -0.52387025 |
| Mean | 22.654339 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 0.45980502 |
| Sum | 77795 |
| Variance | 331.48928 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 680 | |
| 30 | 265 | 7.7% |
| 19 | 226 | 6.6% |
| 31 | 161 | 4.7% |
| 8 | 160 | 4.7% |
| 21 | 159 | 4.6% |
| 29 | 142 | 4.1% |
| 28 | 128 | 3.7% |
| 40 | 101 | 2.9% |
| 50 | 88 | 2.6% |
| Other values (54) | 1324 |
| Value | Count | Frequency (%) |
| 0 | 680 | |
| 1 | 72 | 2.1% |
| 2 | 20 | 0.6% |
| 3 | 29 | 0.8% |
| 4 | 70 | 2.0% |
| 5 | 8 | 0.2% |
| 6 | 37 | 1.1% |
| 7 | 6 | 0.2% |
| 8 | 160 | 4.7% |
| 9 | 21 | 0.6% |
| Value | Count | Frequency (%) |
| 68 | 2 | 0.1% |
| 67 | 29 | 0.8% |
| 66 | 22 | 0.6% |
| 65 | 6 | 0.2% |
| 64 | 73 | |
| 63 | 5 | 0.1% |
| 62 | 8 | 0.2% |
| 61 | 1 | < 0.1% |
| 59 | 17 | 0.5% |
| 58 | 1 | < 0.1% |
Dropoff ID
Real number (ℝ)
High correlation Zeros
| Distinct | 62 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.405649 |
| Minimum | 0 |
|---|---|
| Maximum | 68 |
| Zeros | 616 |
| Zeros (%) | 17.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 53.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 7 |
| median | 21 |
| Q3 | 36 |
| 95-th percentile | 62 |
| Maximum | 68 |
| Range | 68 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 18.618543 |
|---|---|
| Coefficient of variation (CV) | 0.79547218 |
| Kurtosis | -0.57838156 |
| Mean | 23.405649 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | 0.47844504 |
| Sum | 80375 |
| Variance | 346.65014 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 616 | |
| 19 | 217 | 6.3% |
| 15 | 180 | 5.2% |
| 30 | 177 | 5.2% |
| 31 | 146 | 4.3% |
| 40 | 141 | 4.1% |
| 8 | 135 | 3.9% |
| 21 | 130 | 3.8% |
| 28 | 120 | 3.5% |
| 29 | 115 | 3.3% |
| Other values (52) | 1457 |
| Value | Count | Frequency (%) |
| 0 | 616 | |
| 1 | 74 | 2.2% |
| 2 | 8 | 0.2% |
| 3 | 32 | 0.9% |
| 4 | 65 | 1.9% |
| 5 | 8 | 0.2% |
| 6 | 48 | 1.4% |
| 7 | 19 | 0.6% |
| 8 | 135 | 3.9% |
| 9 | 28 | 0.8% |
| Value | Count | Frequency (%) |
| 68 | 1 | < 0.1% |
| 67 | 41 | |
| 66 | 25 | 0.7% |
| 65 | 10 | 0.3% |
| 64 | 87 | |
| 63 | 7 | 0.2% |
| 62 | 5 | 0.1% |
| 61 | 2 | 0.1% |
| 59 | 17 | 0.5% |
| 57 | 12 | 0.3% |
| Distinct | 2870 |
|---|---|
| Distinct (%) | 83.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.7 KiB |
| Minimum | 2024-09-01 08:18:00 |
|---|---|
| Maximum | 2024-09-30 21:46:00 |
Histogram with fixed size bins (bins=50)
| Distinct | 2915 |
|---|---|
| Distinct (%) | 84.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.7 KiB |
| Minimum | 2024-09-01 08:34:00 |
|---|---|
| Maximum | 2024-09-30 21:52:00 |
Histogram with fixed size bins (bins=50)
name_pickup
Text
| Distinct | 64 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.7 KiB |
Length
| Max length | 45 |
|---|---|
| Median length | 31 |
| Mean length | 23.055038 |
| Min length | 7 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Irfersdorf, Am Kirchplatz |
|---|---|
| 2nd row | Wiesenhofen, Kirche |
| 3rd row | Beilngries, Frauenkirche |
| 4th row | Irfersdorf, Am Kirchplatz |
| 5th row | Aschbuch, Waldsiedlung |
| Value | Count | Frequency (%) |
| beilngries | 1414 | 17.5% |
| kinding | 787 | 9.8% |
| bahnhof | 680 | 8.4% |
| straße | 335 | 4.2% |
| frauenkirche | 265 | 3.3% |
| ringstrasse | 226 | 2.8% |
| strasse | 220 | 2.7% |
| haunstetten | 203 | 2.5% |
| gewerbegebiet | 164 | 2.0% |
| eichstaetter | 161 | 2.0% |
| Other values (82) | 3602 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 9560 | 12.1% |
| i | 6266 | 7.9% |
| r | 5978 | 7.6% |
| n | 5976 | 7.5% |
| s | 4882 | 6.2% |
| 4623 | 5.8% | |
| a | 4436 | 5.6% |
| t | 3962 | 5.0% |
| h | 3454 | 4.4% |
| , | 3342 | 4.2% |
| Other values (38) | 26692 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 79171 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 9560 | 12.1% |
| i | 6266 | 7.9% |
| r | 5978 | 7.6% |
| n | 5976 | 7.5% |
| s | 4882 | 6.2% |
| 4623 | 5.8% | |
| a | 4436 | 5.6% |
| t | 3962 | 5.0% |
| h | 3454 | 4.4% |
| , | 3342 | 4.2% |
| Other values (38) | 26692 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 79171 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 9560 | 12.1% |
| i | 6266 | 7.9% |
| r | 5978 | 7.6% |
| n | 5976 | 7.5% |
| s | 4882 | 6.2% |
| 4623 | 5.8% | |
| a | 4436 | 5.6% |
| t | 3962 | 5.0% |
| h | 3454 | 4.4% |
| , | 3342 | 4.2% |
| Other values (38) | 26692 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 79171 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 9560 | 12.1% |
| i | 6266 | 7.9% |
| r | 5978 | 7.6% |
| n | 5976 | 7.5% |
| s | 4882 | 6.2% |
| 4623 | 5.8% | |
| a | 4436 | 5.6% |
| t | 3962 | 5.0% |
| h | 3454 | 4.4% |
| , | 3342 | 4.2% |
| Other values (38) | 26692 |
district_pickup
Categorical
High correlation
| Distinct | 27 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.7 KiB |
| Beilngries | |
|---|---|
| Kinding | |
| Haunstetten | |
| Paulushofen | 116 |
| Wolfsbuch | 115 |
| Other values (22) |
Length
| Max length | 14 |
|---|---|
| Median length | 13 |
| Mean length | 9.3666278 |
| Min length | 7 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Irfersdorf |
|---|---|
| 2nd row | Litterzhofen |
| 3rd row | Beilngries |
| 4th row | Irfersdorf |
| 5th row | Aschbuch |
Common Values
| Value | Count | Frequency (%) |
| Beilngries | 1415 | |
| Kinding | 787 | |
| Haunstetten | 203 | 5.9% |
| Paulushofen | 116 | 3.4% |
| Wolfsbuch | 115 | 3.3% |
| Irfersdorf | 101 | 2.9% |
| Enkering | 92 | 2.7% |
| Hirschberg | 78 | 2.3% |
| Aschbuch | 76 | 2.2% |
| Biberbach | 73 | 2.1% |
| Other values (17) | 378 | 11.0% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| beilngries | 1415 | |
| kinding | 787 | |
| haunstetten | 203 | 5.9% |
| paulushofen | 116 | 3.4% |
| wolfsbuch | 115 | 3.3% |
| irfersdorf | 101 | 2.9% |
| enkering | 92 | 2.7% |
| hirschberg | 78 | 2.3% |
| aschbuch | 76 | 2.2% |
| biberbach | 73 | 2.1% |
| Other values (17) | 378 | 11.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 4818 | |
| n | 4086 | |
| e | 4024 | |
| r | 2519 | 7.8% |
| g | 2459 | 7.6% |
| s | 2261 | 7.0% |
| l | 1681 | 5.2% |
| B | 1514 | 4.7% |
| d | 1080 | 3.4% |
| t | 923 | 2.9% |
| Other values (26) | 6800 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 32165 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 4818 | |
| n | 4086 | |
| e | 4024 | |
| r | 2519 | 7.8% |
| g | 2459 | 7.6% |
| s | 2261 | 7.0% |
| l | 1681 | 5.2% |
| B | 1514 | 4.7% |
| d | 1080 | 3.4% |
| t | 923 | 2.9% |
| Other values (26) | 6800 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 32165 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 4818 | |
| n | 4086 | |
| e | 4024 | |
| r | 2519 | 7.8% |
| g | 2459 | 7.6% |
| s | 2261 | 7.0% |
| l | 1681 | 5.2% |
| B | 1514 | 4.7% |
| d | 1080 | 3.4% |
| t | 923 | 2.9% |
| Other values (26) | 6800 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 32165 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 4818 | |
| n | 4086 | |
| e | 4024 | |
| r | 2519 | 7.8% |
| g | 2459 | 7.6% |
| s | 2261 | 7.0% |
| l | 1681 | 5.2% |
| B | 1514 | 4.7% |
| d | 1080 | 3.4% |
| t | 923 | 2.9% |
| Other values (26) | 6800 |
Pickup Latitude
Real number (ℝ)
High correlation
| Distinct | 64 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49.016356 |
| Minimum | 48.965578 |
|---|---|
| Maximum | 49.069082 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 53.7 KiB |
Quantile statistics
| Minimum | 48.965578 |
|---|---|
| 5-th percentile | 48.976827 |
| Q1 | 48.992168 |
| median | 49.019003 |
| Q3 | 49.035227 |
| 95-th percentile | 49.043035 |
| Maximum | 49.069082 |
| Range | 0.103504 |
| Interquartile range (IQR) | 0.043059 |
Descriptive statistics
| Standard deviation | 0.023411519 |
|---|---|
| Coefficient of variation (CV) | 0.00047762667 |
| Kurtosis | -1.0199412 |
| Mean | 49.016356 |
| Median Absolute Deviation (MAD) | 0.017909 |
| Skewness | -0.13487343 |
| Sum | 168322.17 |
| Variance | 0.00054809921 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 48.992168 | 680 | |
| 49.036378 | 265 | 7.7% |
| 49.033832 | 226 | 6.6% |
| 49.035227 | 161 | 4.7% |
| 49.017505 | 160 | 4.7% |
| 49.033525 | 159 | 4.6% |
| 49.035103 | 142 | 4.1% |
| 49.036912 | 128 | 3.7% |
| 48.994215 | 101 | 2.9% |
| 48.976827 | 88 | 2.6% |
| Other values (54) | 1324 |
| Value | Count | Frequency (%) |
| 48.965578 | 17 | 0.5% |
| 48.97066 | 22 | 0.6% |
| 48.970778 | 23 | 0.7% |
| 48.97449 | 27 | 0.8% |
| 48.975027 | 13 | 0.4% |
| 48.976207 | 21 | 0.6% |
| 48.976818 | 4 | 0.1% |
| 48.976827 | 88 | |
| 48.978988 | 19 | 0.6% |
| 48.98216 | 36 |
| Value | Count | Frequency (%) |
| 49.069082 | 6 | 0.2% |
| 49.068532 | 73 | |
| 49.064045 | 1 | < 0.1% |
| 49.058095 | 5 | 0.1% |
| 49.058008 | 17 | 0.5% |
| 49.054378 | 8 | 0.2% |
| 49.048472 | 29 | 0.8% |
| 49.044913 | 23 | 0.7% |
| 49.043035 | 22 | 0.6% |
| 49.041112 | 62 |
Pickup Longitude
Real number (ℝ)
High correlation
| Distinct | 64 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.447205 |
| Minimum | 11.361228 |
|---|---|
| Maximum | 11.562987 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 53.7 KiB |
Quantile statistics
| Minimum | 11.361228 |
|---|---|
| 5-th percentile | 11.377365 |
| Q1 | 11.390002 |
| median | 11.467885 |
| Q3 | 11.474083 |
| 95-th percentile | 11.520783 |
| Maximum | 11.562987 |
| Range | 0.201759 |
| Interquartile range (IQR) | 0.084081 |
Descriptive statistics
| Standard deviation | 0.049676529 |
|---|---|
| Coefficient of variation (CV) | 0.0043396209 |
| Kurtosis | -0.69206211 |
| Mean | 11.447205 |
| Median Absolute Deviation (MAD) | 0.016447 |
| Skewness | -0.1268469 |
| Sum | 39309.702 |
| Variance | 0.0024677576 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 11.377365 | 680 | |
| 11.470632 | 265 | 7.7% |
| 11.471982 | 226 | 6.6% |
| 11.467885 | 161 | 4.7% |
| 11.404733 | 160 | 4.7% |
| 11.475793 | 159 | 4.6% |
| 11.474083 | 142 | 4.1% |
| 11.471075 | 128 | 3.7% |
| 11.461103 | 101 | 2.9% |
| 11.559612 | 88 | 2.6% |
| Other values (54) | 1324 |
| Value | Count | Frequency (%) |
| 11.361228 | 20 | 0.6% |
| 11.363953 | 72 | 2.1% |
| 11.377365 | 680 | |
| 11.38279 | 70 | 2.0% |
| 11.38727 | 8 | 0.2% |
| 11.390002 | 29 | 0.8% |
| 11.404733 | 160 | 4.7% |
| 11.40739 | 6 | 0.2% |
| 11.408473 | 37 | 1.1% |
| 11.412738 | 22 | 0.6% |
| Value | Count | Frequency (%) |
| 11.562987 | 27 | 0.8% |
| 11.559612 | 88 | |
| 11.534193 | 13 | 0.4% |
| 11.530053 | 19 | 0.6% |
| 11.527642 | 1 | < 0.1% |
| 11.522882 | 2 | 0.1% |
| 11.520783 | 59 | |
| 11.518182 | 2 | 0.1% |
| 11.516585 | 17 | 0.5% |
| 11.50951 | 17 | 0.5% |
name_dropoff
Text
| Distinct | 62 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.7 KiB |
Length
| Max length | 45 |
|---|---|
| Median length | 31 |
| Mean length | 22.863425 |
| Min length | 7 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Kinding, Bahnhof |
|---|---|
| 2nd row | Kinding, Bahnhof |
| 3rd row | Kinding, Bahnhof |
| 4th row | Beilngries, Deutscher Hof |
| 5th row | Beilngries, Kelheimer Straße |
| Value | Count | Frequency (%) |
| beilngries | 1242 | 15.6% |
| kinding | 721 | 9.0% |
| bahnhof | 616 | 7.7% |
| straße | 332 | 4.2% |
| ringstrasse | 217 | 2.7% |
| am | 211 | 2.6% |
| haunstetten | 202 | 2.5% |
| strasse | 189 | 2.4% |
| hirschberg | 182 | 2.3% |
| dorfkapelle | 180 | 2.3% |
| Other values (82) | 3882 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 9181 | 11.7% |
| r | 6058 | 7.7% |
| i | 5817 | 7.4% |
| n | 5620 | 7.2% |
| s | 4831 | 6.2% |
| 4540 | 5.8% | |
| a | 4444 | 5.7% |
| t | 3779 | 4.8% |
| h | 3390 | 4.3% |
| , | 3315 | 4.2% |
| Other values (40) | 27538 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 78513 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 9181 | 11.7% |
| r | 6058 | 7.7% |
| i | 5817 | 7.4% |
| n | 5620 | 7.2% |
| s | 4831 | 6.2% |
| 4540 | 5.8% | |
| a | 4444 | 5.7% |
| t | 3779 | 4.8% |
| h | 3390 | 4.3% |
| , | 3315 | 4.2% |
| Other values (40) | 27538 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 78513 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 9181 | 11.7% |
| r | 6058 | 7.7% |
| i | 5817 | 7.4% |
| n | 5620 | 7.2% |
| s | 4831 | 6.2% |
| 4540 | 5.8% | |
| a | 4444 | 5.7% |
| t | 3779 | 4.8% |
| h | 3390 | 4.3% |
| , | 3315 | 4.2% |
| Other values (40) | 27538 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 78513 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 9181 | 11.7% |
| r | 6058 | 7.7% |
| i | 5817 | 7.4% |
| n | 5620 | 7.2% |
| s | 4831 | 6.2% |
| 4540 | 5.8% | |
| a | 4444 | 5.7% |
| t | 3779 | 4.8% |
| h | 3390 | 4.3% |
| , | 3315 | 4.2% |
| Other values (40) | 27538 |
district_dropoff
Categorical
High correlation
| Distinct | 27 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.7 KiB |
| Beilngries | |
|---|---|
| Kinding | |
| Haunstetten | |
| Hirschberg | |
| Paulushofen | |
| Other values (22) |
Length
| Max length | 14 |
|---|---|
| Median length | 13 |
| Mean length | 9.439138 |
| Min length | 7 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Kinding |
|---|---|
| 2nd row | Kinding |
| 3rd row | Kinding |
| 4th row | Beilngries |
| 5th row | Beilngries |
Common Values
| Value | Count | Frequency (%) |
| Beilngries | 1242 | |
| Kinding | 721 | |
| Haunstetten | 202 | 5.9% |
| Hirschberg | 182 | 5.3% |
| Paulushofen | 153 | 4.5% |
| Irfersdorf | 141 | 4.1% |
| Wolfsbuch | 135 | 3.9% |
| Biberbach | 87 | 2.5% |
| Enkering | 82 | 2.4% |
| Pfraundorf | 81 | 2.4% |
| Other values (17) | 408 | 11.9% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| beilngries | 1242 | |
| kinding | 721 | |
| haunstetten | 202 | 5.9% |
| hirschberg | 182 | 5.3% |
| paulushofen | 153 | 4.5% |
| irfersdorf | 141 | 4.1% |
| wolfsbuch | 135 | 3.9% |
| biberbach | 87 | 2.5% |
| enkering | 82 | 2.4% |
| pfraundorf | 81 | 2.4% |
| Other values (17) | 408 | 11.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 4460 | |
| e | 3928 | |
| n | 3852 | |
| r | 2729 | 8.4% |
| g | 2304 | 7.1% |
| s | 2300 | 7.1% |
| l | 1572 | 4.8% |
| B | 1351 | 4.2% |
| d | 1075 | 3.3% |
| t | 922 | 2.8% |
| Other values (26) | 7921 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 32414 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 4460 | |
| e | 3928 | |
| n | 3852 | |
| r | 2729 | 8.4% |
| g | 2304 | 7.1% |
| s | 2300 | 7.1% |
| l | 1572 | 4.8% |
| B | 1351 | 4.2% |
| d | 1075 | 3.3% |
| t | 922 | 2.8% |
| Other values (26) | 7921 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 32414 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 4460 | |
| e | 3928 | |
| n | 3852 | |
| r | 2729 | 8.4% |
| g | 2304 | 7.1% |
| s | 2300 | 7.1% |
| l | 1572 | 4.8% |
| B | 1351 | 4.2% |
| d | 1075 | 3.3% |
| t | 922 | 2.8% |
| Other values (26) | 7921 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 32414 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 4460 | |
| e | 3928 | |
| n | 3852 | |
| r | 2729 | 8.4% |
| g | 2304 | 7.1% |
| s | 2300 | 7.1% |
| l | 1572 | 4.8% |
| B | 1351 | 4.2% |
| d | 1075 | 3.3% |
| t | 922 | 2.8% |
| Other values (26) | 7921 |
Dropoff Latitude
Real number (ℝ)
High correlation
| Distinct | 62 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49.016306 |
| Minimum | 48.965578 |
|---|---|
| Maximum | 49.069082 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 53.7 KiB |
Quantile statistics
| Minimum | 48.965578 |
|---|---|
| 5-th percentile | 48.976827 |
| Q1 | 48.992168 |
| median | 49.017505 |
| Q3 | 49.035227 |
| 95-th percentile | 49.044913 |
| Maximum | 49.069082 |
| Range | 0.103504 |
| Interquartile range (IQR) | 0.043059 |
Descriptive statistics
| Standard deviation | 0.024015556 |
|---|---|
| Coefficient of variation (CV) | 0.00048995035 |
| Kurtosis | -0.9855651 |
| Mean | 49.016306 |
| Median Absolute Deviation (MAD) | 0.019783 |
| Skewness | -0.086705413 |
| Sum | 168321.99 |
| Variance | 0.00057674694 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 48.992168 | 616 | |
| 49.033832 | 217 | 6.3% |
| 49.03815 | 180 | 5.2% |
| 49.036378 | 177 | 5.2% |
| 49.035227 | 146 | 4.3% |
| 48.994215 | 141 | 4.1% |
| 49.017505 | 135 | 3.9% |
| 49.033525 | 130 | 3.8% |
| 49.036912 | 120 | 3.5% |
| 49.035103 | 115 | 3.3% |
| Other values (52) | 1457 |
| Value | Count | Frequency (%) |
| 48.965578 | 24 | 0.7% |
| 48.97066 | 20 | 0.6% |
| 48.970778 | 24 | 0.7% |
| 48.97449 | 35 | 1.0% |
| 48.975027 | 18 | 0.5% |
| 48.976207 | 23 | 0.7% |
| 48.976818 | 5 | 0.1% |
| 48.976827 | 100 | |
| 48.978988 | 22 | 0.6% |
| 48.98216 | 22 | 0.6% |
| Value | Count | Frequency (%) |
| 49.069082 | 10 | 0.3% |
| 49.068532 | 87 | |
| 49.064045 | 2 | 0.1% |
| 49.058095 | 7 | 0.2% |
| 49.058008 | 17 | 0.5% |
| 49.054378 | 5 | 0.1% |
| 49.048472 | 41 | |
| 49.044913 | 42 | |
| 49.043035 | 25 | 0.7% |
| 49.041112 | 69 |
Dropoff Longitude
Real number (ℝ)
High correlation
| Distinct | 62 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.449012 |
| Minimum | 11.361228 |
|---|---|
| Maximum | 11.562987 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 53.7 KiB |
Quantile statistics
| Minimum | 11.361228 |
|---|---|
| 5-th percentile | 11.377365 |
| Q1 | 11.404733 |
| median | 11.467885 |
| Q3 | 11.474083 |
| 95-th percentile | 11.530053 |
| Maximum | 11.562987 |
| Range | 0.201759 |
| Interquartile range (IQR) | 0.06935 |
Descriptive statistics
| Standard deviation | 0.049299018 |
|---|---|
| Coefficient of variation (CV) | 0.0043059626 |
| Kurtosis | -0.5357013 |
| Mean | 11.449012 |
| Median Absolute Deviation (MAD) | 0.016447 |
| Skewness | -0.084846696 |
| Sum | 39315.907 |
| Variance | 0.0024303932 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 11.377365 | 616 | |
| 11.471982 | 217 | 6.3% |
| 11.451488 | 180 | 5.2% |
| 11.470632 | 177 | 5.2% |
| 11.467885 | 146 | 4.3% |
| 11.461103 | 141 | 4.1% |
| 11.404733 | 135 | 3.9% |
| 11.475793 | 130 | 3.8% |
| 11.471075 | 120 | 3.5% |
| 11.474083 | 115 | 3.3% |
| Other values (52) | 1457 |
| Value | Count | Frequency (%) |
| 11.361228 | 8 | 0.2% |
| 11.363953 | 74 | 2.2% |
| 11.377365 | 616 | |
| 11.38279 | 65 | 1.9% |
| 11.38727 | 8 | 0.2% |
| 11.390002 | 32 | 0.9% |
| 11.404733 | 135 | 3.9% |
| 11.40739 | 10 | 0.3% |
| 11.408473 | 48 | 1.4% |
| 11.412738 | 25 | 0.7% |
| Value | Count | Frequency (%) |
| 11.562987 | 35 | 1.0% |
| 11.559612 | 100 | |
| 11.534193 | 18 | 0.5% |
| 11.53071 | 1 | < 0.1% |
| 11.530053 | 24 | 0.7% |
| 11.522882 | 1 | < 0.1% |
| 11.520783 | 43 | |
| 11.518182 | 4 | 0.1% |
| 11.516585 | 17 | 0.5% |
| 11.50951 | 24 | 0.7% |
Interactions
Correlations
| Booking ID | Dropoff ID | Dropoff Latitude | Dropoff Longitude | Passenger status | Passengers | Pickup ID | Pickup Latitude | Pickup Longitude | Status | district_dropoff | district_pickup | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Booking ID | 1.000 | -0.043 | -0.027 | -0.042 | 0.056 | 0.054 | -0.063 | 0.006 | -0.026 | 0.053 | 0.123 | 0.146 |
| Dropoff ID | -0.043 | 1.000 | 0.296 | 0.751 | 0.050 | -0.008 | 0.009 | -0.068 | -0.027 | 0.033 | 0.875 | 0.269 |
| Dropoff Latitude | -0.027 | 0.296 | 1.000 | 0.177 | 0.045 | -0.001 | -0.081 | -0.274 | -0.208 | 0.025 | 0.876 | 0.274 |
| Dropoff Longitude | -0.042 | 0.751 | 0.177 | 1.000 | 0.000 | 0.011 | -0.039 | -0.197 | -0.083 | 0.034 | 0.911 | 0.271 |
| Passenger status | 0.056 | 0.050 | 0.045 | 0.000 | 1.000 | 0.068 | 0.063 | 0.102 | 0.088 | 0.999 | 0.105 | 0.133 |
| Passengers | 0.054 | -0.008 | -0.001 | 0.011 | 0.068 | 1.000 | -0.027 | -0.026 | 0.014 | 0.041 | 0.053 | 0.100 |
| Pickup ID | -0.063 | 0.009 | -0.081 | -0.039 | 0.063 | -0.027 | 1.000 | 0.356 | 0.742 | 0.056 | 0.283 | 0.868 |
| Pickup Latitude | 0.006 | -0.068 | -0.274 | -0.197 | 0.102 | -0.026 | 0.356 | 1.000 | 0.244 | 0.067 | 0.280 | 0.873 |
| Pickup Longitude | -0.026 | -0.027 | -0.208 | -0.083 | 0.088 | 0.014 | 0.742 | 0.244 | 1.000 | 0.066 | 0.263 | 0.908 |
| Status | 0.053 | 0.033 | 0.025 | 0.034 | 0.999 | 0.041 | 0.056 | 0.067 | 0.066 | 1.000 | 0.080 | 0.066 |
| district_dropoff | 0.123 | 0.875 | 0.876 | 0.911 | 0.105 | 0.053 | 0.283 | 0.280 | 0.263 | 0.080 | 1.000 | 0.178 |
| district_pickup | 0.146 | 0.269 | 0.274 | 0.271 | 0.133 | 0.100 | 0.868 | 0.873 | 0.908 | 0.066 | 0.178 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| Booking ID | Status | Passenger status | Passengers | Pickup ID | Dropoff ID | Actual Pickup Time | Actual Dropoff Time | name_pickup | district_pickup | Pickup Latitude | Pickup Longitude | name_dropoff | district_dropoff | Dropoff Latitude | Dropoff Longitude | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 253212 | Cancelled by client | Cancelled | 1 | 40 | 0 | 2024-09-01 08:18:00 | 2024-09-01 08:34:00 | Irfersdorf, Am Kirchplatz | Irfersdorf | 48.994215 | 11.461103 | Kinding, Bahnhof | Kinding | 48.992168 | 11.377365 |
| 2 | 253369 | Cancelled by client | Cancelled | 3 | 66 | 0 | 2024-09-01 08:46:00 | 2024-09-01 09:09:00 | Wiesenhofen, Kirche | Litterzhofen | 49.043035 | 11.412738 | Kinding, Bahnhof | Kinding | 48.992168 | 11.377365 |
| 3 | 253808 | Cancelled by driver | Cancelled | 2 | 30 | 0 | 2024-09-01 08:56:00 | 2024-09-01 09:09:00 | Beilngries, Frauenkirche | Beilngries | 49.036378 | 11.470632 | Kinding, Bahnhof | Kinding | 48.992168 | 11.377365 |
| 4 | 253782 | Validated | Trip completed | 2 | 40 | 21 | 2024-09-01 09:14:00 | 2024-09-01 09:25:00 | Irfersdorf, Am Kirchplatz | Irfersdorf | 48.994215 | 11.461103 | Beilngries, Deutscher Hof | Beilngries | 49.033525 | 11.475793 |
| 5 | 252382 | Cancelled by driver | Cancelled | 1 | 46 | 22 | 2024-09-01 09:41:00 | 2024-09-01 09:49:00 | Aschbuch, Waldsiedlung | Aschbuch | 48.976207 | 11.491877 | Beilngries, Kelheimer Straße | Beilngries | 49.032928 | 11.479163 |
| 6 | 251869 | Validated | Trip completed | 3 | 27 | 0 | 2024-09-01 09:54:00 | 2024-09-01 10:06:00 | Beilngries, Hafen | Beilngries | 49.041112 | 11.471240 | Kinding, Bahnhof | Kinding | 48.992168 | 11.377365 |
| 7 | 251083 | Validated | Trip completed | 1 | 20 | 9 | 2024-09-01 10:39:00 | 2024-09-01 10:46:00 | Beilngries, ZOB | Beilngries | 49.032173 | 11.476295 | Unteremmendorf, Wendeschleife | Unteremmendorf | 48.992112 | 11.434157 |
| 8 | 253882 | Cancelled by client | Cancelled | 1 | 38 | 29 | 2024-09-01 10:29:00 | 2024-09-01 10:38:00 | Paulushofen, Dorfstraße | Paulushofen | 49.010337 | 11.502283 | Beilngries, Rathaus | Beilngries | 49.035103 | 11.474083 |
| 9 | 251191 | Cancelled by driver | Cancelled | 2 | 19 | 0 | 2024-09-01 10:36:00 | 2024-09-01 10:55:00 | Beilngries, Ringstrasse | Beilngries | 49.033832 | 11.471982 | Kinding, Bahnhof | Kinding | 48.992168 | 11.377365 |
| 10 | 253916 | Validated | Trip completed | 2 | 19 | 0 | 2024-09-01 10:36:00 | 2024-09-01 10:52:00 | Beilngries, Ringstrasse | Beilngries | 49.033832 | 11.471982 | Kinding, Bahnhof | Kinding | 48.992168 | 11.377365 |
| Booking ID | Status | Passenger status | Passengers | Pickup ID | Dropoff ID | Actual Pickup Time | Actual Dropoff Time | name_pickup | district_pickup | Pickup Latitude | Pickup Longitude | name_dropoff | district_dropoff | Dropoff Latitude | Dropoff Longitude | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3827 | 270318 | Cancelled by client | Cancelled | 3 | 0 | 64 | 2024-09-30 19:57:00 | 2024-09-30 20:20:00 | Kinding, Bahnhof | Kinding | 48.992168 | 11.377365 | Plankstetten, Biberbacher Straße | Biberbach | 49.068532 | 11.455142 |
| 3828 | 263021 | Validated | Trip completed | 1 | 30 | 40 | 2024-09-30 20:08:00 | 2024-09-30 20:14:00 | Beilngries, Frauenkirche | Beilngries | 49.036378 | 11.470632 | Irfersdorf, Am Kirchplatz | Irfersdorf | 48.994215 | 11.461103 |
| 3829 | 262045 | Cancelled by driver | Cancelled | 1 | 0 | 18 | 2024-09-30 20:55:00 | 2024-09-30 21:07:00 | Kinding, Bahnhof | Kinding | 48.992168 | 11.377365 | Beilngries, Utzmuehlweg | Beilngries | 49.039483 | 11.467702 |
| 3830 | 269620 | Validated | Trip completed | 1 | 0 | 29 | 2024-09-30 20:55:00 | 2024-09-30 21:06:00 | Kinding, Bahnhof | Kinding | 48.992168 | 11.377365 | Beilngries, Rathaus | Beilngries | 49.035103 | 11.474083 |
| 3831 | 269717 | Cancelled by client | Cancelled | 3 | 0 | 28 | 2024-09-30 20:54:00 | 2024-09-30 21:09:00 | Kinding, Bahnhof | Kinding | 48.992168 | 11.377365 | Beilngries, Neumarkter Straße | Beilngries | 49.036912 | 11.471075 |
| 3832 | 270319 | Cancelled by driver | Cancelled | 3 | 0 | 64 | 2024-09-30 20:55:00 | 2024-09-30 21:42:00 | Kinding, Bahnhof | Kinding | 48.992168 | 11.377365 | Plankstetten, Biberbacher Straße | Biberbach | 49.068532 | 11.455142 |
| 3833 | 268219 | Validated | Trip completed | 1 | 4 | 1 | 2024-09-30 21:20:00 | 2024-09-30 21:23:00 | Kinding, Marktplatz | Kinding | 49.000562 | 11.382790 | Enkering, Maibaum | Enkering | 48.992498 | 11.363953 |
| 3834 | 269630 | Cancelled by client | Cancelled | 1 | 2 | 10 | 2024-09-30 21:25:00 | 2024-09-30 21:33:00 | Enkering, Feuerwehrhaus | Enkering | 48.993652 | 11.361228 | Pfraundorf, Dorfplatz | Pfraundorf | 49.005142 | 11.445253 |
| 3835 | 269524 | Cancelled by client | Cancelled | 1 | 19 | 42 | 2024-09-30 21:37:00 | 2024-09-30 21:47:00 | Beilngries, Ringstrasse | Beilngries | 49.033832 | 11.471982 | Grampersdorf, Landstrasse | Grampersdorf | 48.970778 | 11.476563 |
| 3836 | 269863 | Validated | Trip completed | 1 | 33 | 15 | 2024-09-30 21:46:00 | 2024-09-30 21:52:00 | Beilngries, Bauhofstraße | Beilngries | 49.031608 | 11.461872 | Hirschberg, Dorfkapelle | Hirschberg | 49.038150 | 11.451488 |